Data Imports

Historical GL data loads during implementation cycles to avoid lengthy Config Pack Uploads

Typically takes 90% less time than a configuration package.

Loading large monthly journal entries.
Reduce loading and wait times on configuration packages and edit in Excel.
Ability to load Accounts Payable transactions into General Journals
Ability to load Accounts Receivable transactions into General Journals
Ability to use translation table in Business Central to avoid mapping in file

Map old Chart of Accounts to New Chart of Accounts + Dimensions in Business Central
Removes the complexities of having to Map this in the import file

Data Migrations

- When setting up new companies

- When pushing data between sandboxes and production (or vice versa)

- Allows you to do mass imports from company to company for dozens of standard tables in Business Central

Sales (Customer, Setups, Items, etc.)
Purchasing (Vendors, Setups, Items, etc.)
General Ledger (COA, Dimensions, Setups, etc.)
Fixed Assets (FA Card, Setups,)
Financial Reports

When creating new companies within the same organization

Bi-directionally pushing data between different business central companies like production vs test.

We are not exporting and importing like a configuration package which could take hours to move all of this data

We are doing a direct data transfer and only takes minutes instead of hours

Pre-filter the data

only move customers in canada

only move customers with posting group domestic

only move revenue chart of accounts

only move items that have been updated in the last 12 months

only move items with a certain posting group

etc.

Data Imports and Migration

by ERP Connect Consulting LLC